﻿SELECT S.idPath,
/* CONVERT(UNHEX(HEX(CONVERT(CONVERT(P.strPath USING utf8) USING latin1))), CHAR) AS strPath, */
P.strPath AS strPath,
S.idSong AS idFile,
/* CONVERT(UNHEX(HEX(CONVERT(CONVERT(S.strFileName USING utf8) USING latin1))), CHAR) AS strFilename */
S.strFileName AS strFilename
FROM song AS S
INNER JOIN path AS P ON P.idPath = S.idPath;